mysql after 报错 |
您所在的位置:网站首页 › MySQL启动报错 ibtmp1 › mysql after 报错 |
出错的内容: 备注:这里大概意思是意外关闭数据库造成的错误,让我检查日志文件和端口 日志文件报错: InnoDB: using atomic writes. 2020-08-13 20:31:52 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2020-08-13 20:31:52 0 [Note] InnoDB: Uses event mutexes 2020-08-13 20:31:52 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2020-08-13 20:31:52 0 [Note] InnoDB: Number of pools: 1 2020-08-13 20:31:52 0 [Note] InnoDB: Using SSE2 crc32 instructions 2020-08-13 20:31:52 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2020-08-13 20:31:52 0 [Note] InnoDB: Completed initialization of buffer pool 2020-08-13 20:31:52 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2020-08-13 20:31:52 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-08-13 20:31:52 0 [Note] InnoDB: Setting file 'E:\xammp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-08-13 20:31:52 0 [Note] InnoDB: File 'E:\xammp\mysql\data\ibtmp1' size is now 12 MB. 2020-08-13 20:31:52 0 [Note] InnoDB: Waiting for purge to start 2020-08-13 20:31:52 0 [Note] InnoDB: 10.4.11 started; log sequence number 447771; transaction id 807 2020-08-13 20:31:52 0 [Note] InnoDB: Loading buffer pool(s) from E:\xammp\mysql\data\ib_buffer_pool 2020-08-13 20:31:52 0 [Note] Plugin 'FEEDBACK' is disabled. 2020-08-13 20:31:52 0 [Note] Server socket created on IP: '::'. 解决办法: 方法一: 改端口。打开Mysql的my.ini文件,将端口3306改成3307或者3316都可 改完后保存重新启动 方法二: 方法三: 在mysql/bin/my.ini 文件下的[mysqld]加一个:innodb_force_recovery = 4 保存重启 方法四: 将图中的带@的文件删除,请注意看时间,和你出错的时间相仿的。 重启 以上就是关于这个问题的解决办法,如果还是不能解决,请百度。 |
今日新闻 |
推荐新闻 |
CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3 |